package com.dffl.es.esstudy.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TSupplierSpuExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TSupplierSpuExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameIsNull() {
            addCriterion("supplier_spu_name is null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameIsNotNull() {
            addCriterion("supplier_spu_name is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameEqualTo(String value) {
            addCriterion("supplier_spu_name =", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameNotEqualTo(String value) {
            addCriterion("supplier_spu_name <>", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameGreaterThan(String value) {
            addCriterion("supplier_spu_name >", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_spu_name >=", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameLessThan(String value) {
            addCriterion("supplier_spu_name <", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameLessThanOrEqualTo(String value) {
            addCriterion("supplier_spu_name <=", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameLike(String value) {
            addCriterion("supplier_spu_name like", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameNotLike(String value) {
            addCriterion("supplier_spu_name not like", value, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameIn(List<String> values) {
            addCriterion("supplier_spu_name in", values, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameNotIn(List<String> values) {
            addCriterion("supplier_spu_name not in", values, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameBetween(String value1, String value2) {
            addCriterion("supplier_spu_name between", value1, value2, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuNameNotBetween(String value1, String value2) {
            addCriterion("supplier_spu_name not between", value1, value2, "supplierSpuName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeIsNull() {
            addCriterion("supplier_spu_code is null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeIsNotNull() {
            addCriterion("supplier_spu_code is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeEqualTo(String value) {
            addCriterion("supplier_spu_code =", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeNotEqualTo(String value) {
            addCriterion("supplier_spu_code <>", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeGreaterThan(String value) {
            addCriterion("supplier_spu_code >", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_spu_code >=", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeLessThan(String value) {
            addCriterion("supplier_spu_code <", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeLessThanOrEqualTo(String value) {
            addCriterion("supplier_spu_code <=", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeLike(String value) {
            addCriterion("supplier_spu_code like", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeNotLike(String value) {
            addCriterion("supplier_spu_code not like", value, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeIn(List<String> values) {
            addCriterion("supplier_spu_code in", values, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeNotIn(List<String> values) {
            addCriterion("supplier_spu_code not in", values, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeBetween(String value1, String value2) {
            addCriterion("supplier_spu_code between", value1, value2, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuCodeNotBetween(String value1, String value2) {
            addCriterion("supplier_spu_code not between", value1, value2, "supplierSpuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeIsNull() {
            addCriterion("spu_code is null");
            return (Criteria) this;
        }

        public Criteria andSpuCodeIsNotNull() {
            addCriterion("spu_code is not null");
            return (Criteria) this;
        }

        public Criteria andSpuCodeEqualTo(String value) {
            addCriterion("spu_code =", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeNotEqualTo(String value) {
            addCriterion("spu_code <>", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeGreaterThan(String value) {
            addCriterion("spu_code >", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spu_code >=", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeLessThan(String value) {
            addCriterion("spu_code <", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeLessThanOrEqualTo(String value) {
            addCriterion("spu_code <=", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeLike(String value) {
            addCriterion("spu_code like", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeNotLike(String value) {
            addCriterion("spu_code not like", value, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeIn(List<String> values) {
            addCriterion("spu_code in", values, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeNotIn(List<String> values) {
            addCriterion("spu_code not in", values, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeBetween(String value1, String value2) {
            addCriterion("spu_code between", value1, value2, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSpuCodeNotBetween(String value1, String value2) {
            addCriterion("spu_code not between", value1, value2, "spuCode");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNull() {
            addCriterion("supplier_name is null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNotNull() {
            addCriterion("supplier_name is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameEqualTo(String value) {
            addCriterion("supplier_name =", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotEqualTo(String value) {
            addCriterion("supplier_name <>", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThan(String value) {
            addCriterion("supplier_name >", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_name >=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThan(String value) {
            addCriterion("supplier_name <", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThanOrEqualTo(String value) {
            addCriterion("supplier_name <=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLike(String value) {
            addCriterion("supplier_name like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotLike(String value) {
            addCriterion("supplier_name not like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIn(List<String> values) {
            addCriterion("supplier_name in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotIn(List<String> values) {
            addCriterion("supplier_name not in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameBetween(String value1, String value2) {
            addCriterion("supplier_name between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotBetween(String value1, String value2) {
            addCriterion("supplier_name not between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNull() {
            addCriterion("supplier_id is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNotNull() {
            addCriterion("supplier_id is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdEqualTo(String value) {
            addCriterion("supplier_id =", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotEqualTo(String value) {
            addCriterion("supplier_id <>", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThan(String value) {
            addCriterion("supplier_id >", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_id >=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThan(String value) {
            addCriterion("supplier_id <", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThanOrEqualTo(String value) {
            addCriterion("supplier_id <=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLike(String value) {
            addCriterion("supplier_id like", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotLike(String value) {
            addCriterion("supplier_id not like", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIn(List<String> values) {
            addCriterion("supplier_id in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotIn(List<String> values) {
            addCriterion("supplier_id not in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdBetween(String value1, String value2) {
            addCriterion("supplier_id between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotBetween(String value1, String value2) {
            addCriterion("supplier_id not between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andHeadPicIsNull() {
            addCriterion("head_pic is null");
            return (Criteria) this;
        }

        public Criteria andHeadPicIsNotNull() {
            addCriterion("head_pic is not null");
            return (Criteria) this;
        }

        public Criteria andHeadPicEqualTo(String value) {
            addCriterion("head_pic =", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicNotEqualTo(String value) {
            addCriterion("head_pic <>", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicGreaterThan(String value) {
            addCriterion("head_pic >", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicGreaterThanOrEqualTo(String value) {
            addCriterion("head_pic >=", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicLessThan(String value) {
            addCriterion("head_pic <", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicLessThanOrEqualTo(String value) {
            addCriterion("head_pic <=", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicLike(String value) {
            addCriterion("head_pic like", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicNotLike(String value) {
            addCriterion("head_pic not like", value, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicIn(List<String> values) {
            addCriterion("head_pic in", values, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicNotIn(List<String> values) {
            addCriterion("head_pic not in", values, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicBetween(String value1, String value2) {
            addCriterion("head_pic between", value1, value2, "headPic");
            return (Criteria) this;
        }

        public Criteria andHeadPicNotBetween(String value1, String value2) {
            addCriterion("head_pic not between", value1, value2, "headPic");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleIsNull() {
            addCriterion("supplier_spu_subtitle is null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleIsNotNull() {
            addCriterion("supplier_spu_subtitle is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleEqualTo(String value) {
            addCriterion("supplier_spu_subtitle =", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleNotEqualTo(String value) {
            addCriterion("supplier_spu_subtitle <>", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleGreaterThan(String value) {
            addCriterion("supplier_spu_subtitle >", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_spu_subtitle >=", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleLessThan(String value) {
            addCriterion("supplier_spu_subtitle <", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleLessThanOrEqualTo(String value) {
            addCriterion("supplier_spu_subtitle <=", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleLike(String value) {
            addCriterion("supplier_spu_subtitle like", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleNotLike(String value) {
            addCriterion("supplier_spu_subtitle not like", value, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleIn(List<String> values) {
            addCriterion("supplier_spu_subtitle in", values, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleNotIn(List<String> values) {
            addCriterion("supplier_spu_subtitle not in", values, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleBetween(String value1, String value2) {
            addCriterion("supplier_spu_subtitle between", value1, value2, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuSubtitleNotBetween(String value1, String value2) {
            addCriterion("supplier_spu_subtitle not between", value1, value2, "supplierSpuSubtitle");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdIsNull() {
            addCriterion("spu_back_category_id is null");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdIsNotNull() {
            addCriterion("spu_back_category_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdEqualTo(Long value) {
            addCriterion("spu_back_category_id =", value, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdNotEqualTo(Long value) {
            addCriterion("spu_back_category_id <>", value, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdGreaterThan(Long value) {
            addCriterion("spu_back_category_id >", value, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdGreaterThanOrEqualTo(Long value) {
            addCriterion("spu_back_category_id >=", value, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdLessThan(Long value) {
            addCriterion("spu_back_category_id <", value, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdLessThanOrEqualTo(Long value) {
            addCriterion("spu_back_category_id <=", value, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdIn(List<Long> values) {
            addCriterion("spu_back_category_id in", values, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdNotIn(List<Long> values) {
            addCriterion("spu_back_category_id not in", values, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdBetween(Long value1, Long value2) {
            addCriterion("spu_back_category_id between", value1, value2, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuBackCategoryIdNotBetween(Long value1, Long value2) {
            addCriterion("spu_back_category_id not between", value1, value2, "spuBackCategoryId");
            return (Criteria) this;
        }

        public Criteria andSpuTypeIsNull() {
            addCriterion("spu_type is null");
            return (Criteria) this;
        }

        public Criteria andSpuTypeIsNotNull() {
            addCriterion("spu_type is not null");
            return (Criteria) this;
        }

        public Criteria andSpuTypeEqualTo(Integer value) {
            addCriterion("spu_type =", value, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeNotEqualTo(Integer value) {
            addCriterion("spu_type <>", value, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeGreaterThan(Integer value) {
            addCriterion("spu_type >", value, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("spu_type >=", value, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeLessThan(Integer value) {
            addCriterion("spu_type <", value, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeLessThanOrEqualTo(Integer value) {
            addCriterion("spu_type <=", value, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeIn(List<Integer> values) {
            addCriterion("spu_type in", values, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeNotIn(List<Integer> values) {
            addCriterion("spu_type not in", values, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeBetween(Integer value1, Integer value2) {
            addCriterion("spu_type between", value1, value2, "spuType");
            return (Criteria) this;
        }

        public Criteria andSpuTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("spu_type not between", value1, value2, "spuType");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdIsNull() {
            addCriterion("purchase_group_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdIsNotNull() {
            addCriterion("purchase_group_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdEqualTo(String value) {
            addCriterion("purchase_group_id =", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdNotEqualTo(String value) {
            addCriterion("purchase_group_id <>", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdGreaterThan(String value) {
            addCriterion("purchase_group_id >", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_group_id >=", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdLessThan(String value) {
            addCriterion("purchase_group_id <", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdLessThanOrEqualTo(String value) {
            addCriterion("purchase_group_id <=", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdLike(String value) {
            addCriterion("purchase_group_id like", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdNotLike(String value) {
            addCriterion("purchase_group_id not like", value, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdIn(List<String> values) {
            addCriterion("purchase_group_id in", values, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdNotIn(List<String> values) {
            addCriterion("purchase_group_id not in", values, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdBetween(String value1, String value2) {
            addCriterion("purchase_group_id between", value1, value2, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseGroupIdNotBetween(String value1, String value2) {
            addCriterion("purchase_group_id not between", value1, value2, "purchaseGroupId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdIsNull() {
            addCriterion("purchase_team_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdIsNotNull() {
            addCriterion("purchase_team_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdEqualTo(String value) {
            addCriterion("purchase_team_id =", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdNotEqualTo(String value) {
            addCriterion("purchase_team_id <>", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdGreaterThan(String value) {
            addCriterion("purchase_team_id >", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_team_id >=", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdLessThan(String value) {
            addCriterion("purchase_team_id <", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdLessThanOrEqualTo(String value) {
            addCriterion("purchase_team_id <=", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdLike(String value) {
            addCriterion("purchase_team_id like", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdNotLike(String value) {
            addCriterion("purchase_team_id not like", value, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdIn(List<String> values) {
            addCriterion("purchase_team_id in", values, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdNotIn(List<String> values) {
            addCriterion("purchase_team_id not in", values, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdBetween(String value1, String value2) {
            addCriterion("purchase_team_id between", value1, value2, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaseTeamIdNotBetween(String value1, String value2) {
            addCriterion("purchase_team_id not between", value1, value2, "purchaseTeamId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdIsNull() {
            addCriterion("purchaser_id is null");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdIsNotNull() {
            addCriterion("purchaser_id is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdEqualTo(Long value) {
            addCriterion("purchaser_id =", value, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdNotEqualTo(Long value) {
            addCriterion("purchaser_id <>", value, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdGreaterThan(Long value) {
            addCriterion("purchaser_id >", value, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("purchaser_id >=", value, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdLessThan(Long value) {
            addCriterion("purchaser_id <", value, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdLessThanOrEqualTo(Long value) {
            addCriterion("purchaser_id <=", value, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdIn(List<Long> values) {
            addCriterion("purchaser_id in", values, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdNotIn(List<Long> values) {
            addCriterion("purchaser_id not in", values, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdBetween(Long value1, Long value2) {
            addCriterion("purchaser_id between", value1, value2, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIdNotBetween(Long value1, Long value2) {
            addCriterion("purchaser_id not between", value1, value2, "purchaserId");
            return (Criteria) this;
        }

        public Criteria andPurchaserIsNull() {
            addCriterion("purchaser is null");
            return (Criteria) this;
        }

        public Criteria andPurchaserIsNotNull() {
            addCriterion("purchaser is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaserEqualTo(String value) {
            addCriterion("purchaser =", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserNotEqualTo(String value) {
            addCriterion("purchaser <>", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserGreaterThan(String value) {
            addCriterion("purchaser >", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserGreaterThanOrEqualTo(String value) {
            addCriterion("purchaser >=", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserLessThan(String value) {
            addCriterion("purchaser <", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserLessThanOrEqualTo(String value) {
            addCriterion("purchaser <=", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserLike(String value) {
            addCriterion("purchaser like", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserNotLike(String value) {
            addCriterion("purchaser not like", value, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserIn(List<String> values) {
            addCriterion("purchaser in", values, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserNotIn(List<String> values) {
            addCriterion("purchaser not in", values, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserBetween(String value1, String value2) {
            addCriterion("purchaser between", value1, value2, "purchaser");
            return (Criteria) this;
        }

        public Criteria andPurchaserNotBetween(String value1, String value2) {
            addCriterion("purchaser not between", value1, value2, "purchaser");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNull() {
            addCriterion("brand_id is null");
            return (Criteria) this;
        }

        public Criteria andBrandIdIsNotNull() {
            addCriterion("brand_id is not null");
            return (Criteria) this;
        }

        public Criteria andBrandIdEqualTo(Long value) {
            addCriterion("brand_id =", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotEqualTo(Long value) {
            addCriterion("brand_id <>", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThan(Long value) {
            addCriterion("brand_id >", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdGreaterThanOrEqualTo(Long value) {
            addCriterion("brand_id >=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThan(Long value) {
            addCriterion("brand_id <", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdLessThanOrEqualTo(Long value) {
            addCriterion("brand_id <=", value, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdIn(List<Long> values) {
            addCriterion("brand_id in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotIn(List<Long> values) {
            addCriterion("brand_id not in", values, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdBetween(Long value1, Long value2) {
            addCriterion("brand_id between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andBrandIdNotBetween(Long value1, Long value2) {
            addCriterion("brand_id not between", value1, value2, "brandId");
            return (Criteria) this;
        }

        public Criteria andManufactorIsNull() {
            addCriterion("manufactor is null");
            return (Criteria) this;
        }

        public Criteria andManufactorIsNotNull() {
            addCriterion("manufactor is not null");
            return (Criteria) this;
        }

        public Criteria andManufactorEqualTo(String value) {
            addCriterion("manufactor =", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorNotEqualTo(String value) {
            addCriterion("manufactor <>", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorGreaterThan(String value) {
            addCriterion("manufactor >", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorGreaterThanOrEqualTo(String value) {
            addCriterion("manufactor >=", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorLessThan(String value) {
            addCriterion("manufactor <", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorLessThanOrEqualTo(String value) {
            addCriterion("manufactor <=", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorLike(String value) {
            addCriterion("manufactor like", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorNotLike(String value) {
            addCriterion("manufactor not like", value, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorIn(List<String> values) {
            addCriterion("manufactor in", values, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorNotIn(List<String> values) {
            addCriterion("manufactor not in", values, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorBetween(String value1, String value2) {
            addCriterion("manufactor between", value1, value2, "manufactor");
            return (Criteria) this;
        }

        public Criteria andManufactorNotBetween(String value1, String value2) {
            addCriterion("manufactor not between", value1, value2, "manufactor");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysIsNull() {
            addCriterion("delivery_days is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysIsNotNull() {
            addCriterion("delivery_days is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysEqualTo(Integer value) {
            addCriterion("delivery_days =", value, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysNotEqualTo(Integer value) {
            addCriterion("delivery_days <>", value, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysGreaterThan(Integer value) {
            addCriterion("delivery_days >", value, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_days >=", value, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysLessThan(Integer value) {
            addCriterion("delivery_days <", value, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_days <=", value, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysIn(List<Integer> values) {
            addCriterion("delivery_days in", values, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysNotIn(List<Integer> values) {
            addCriterion("delivery_days not in", values, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysBetween(Integer value1, Integer value2) {
            addCriterion("delivery_days between", value1, value2, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andDeliveryDaysNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_days not between", value1, value2, "deliveryDays");
            return (Criteria) this;
        }

        public Criteria andMadeInIsNull() {
            addCriterion("made_in is null");
            return (Criteria) this;
        }

        public Criteria andMadeInIsNotNull() {
            addCriterion("made_in is not null");
            return (Criteria) this;
        }

        public Criteria andMadeInEqualTo(String value) {
            addCriterion("made_in =", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInNotEqualTo(String value) {
            addCriterion("made_in <>", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInGreaterThan(String value) {
            addCriterion("made_in >", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInGreaterThanOrEqualTo(String value) {
            addCriterion("made_in >=", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInLessThan(String value) {
            addCriterion("made_in <", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInLessThanOrEqualTo(String value) {
            addCriterion("made_in <=", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInLike(String value) {
            addCriterion("made_in like", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInNotLike(String value) {
            addCriterion("made_in not like", value, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInIn(List<String> values) {
            addCriterion("made_in in", values, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInNotIn(List<String> values) {
            addCriterion("made_in not in", values, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInBetween(String value1, String value2) {
            addCriterion("made_in between", value1, value2, "madeIn");
            return (Criteria) this;
        }

        public Criteria andMadeInNotBetween(String value1, String value2) {
            addCriterion("made_in not between", value1, value2, "madeIn");
            return (Criteria) this;
        }

        public Criteria andIsImportIsNull() {
            addCriterion("is_import is null");
            return (Criteria) this;
        }

        public Criteria andIsImportIsNotNull() {
            addCriterion("is_import is not null");
            return (Criteria) this;
        }

        public Criteria andIsImportEqualTo(Boolean value) {
            addCriterion("is_import =", value, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportNotEqualTo(Boolean value) {
            addCriterion("is_import <>", value, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportGreaterThan(Boolean value) {
            addCriterion("is_import >", value, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_import >=", value, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportLessThan(Boolean value) {
            addCriterion("is_import <", value, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportLessThanOrEqualTo(Boolean value) {
            addCriterion("is_import <=", value, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportIn(List<Boolean> values) {
            addCriterion("is_import in", values, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportNotIn(List<Boolean> values) {
            addCriterion("is_import not in", values, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportBetween(Boolean value1, Boolean value2) {
            addCriterion("is_import between", value1, value2, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsImportNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_import not between", value1, value2, "isImport");
            return (Criteria) this;
        }

        public Criteria andIsDangerousIsNull() {
            addCriterion("is_dangerous is null");
            return (Criteria) this;
        }

        public Criteria andIsDangerousIsNotNull() {
            addCriterion("is_dangerous is not null");
            return (Criteria) this;
        }

        public Criteria andIsDangerousEqualTo(Boolean value) {
            addCriterion("is_dangerous =", value, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousNotEqualTo(Boolean value) {
            addCriterion("is_dangerous <>", value, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousGreaterThan(Boolean value) {
            addCriterion("is_dangerous >", value, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_dangerous >=", value, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousLessThan(Boolean value) {
            addCriterion("is_dangerous <", value, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousLessThanOrEqualTo(Boolean value) {
            addCriterion("is_dangerous <=", value, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousIn(List<Boolean> values) {
            addCriterion("is_dangerous in", values, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousNotIn(List<Boolean> values) {
            addCriterion("is_dangerous not in", values, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousBetween(Boolean value1, Boolean value2) {
            addCriterion("is_dangerous between", value1, value2, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsDangerousNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_dangerous not between", value1, value2, "isDangerous");
            return (Criteria) this;
        }

        public Criteria andIsOverseasIsNull() {
            addCriterion("is_overseas is null");
            return (Criteria) this;
        }

        public Criteria andIsOverseasIsNotNull() {
            addCriterion("is_overseas is not null");
            return (Criteria) this;
        }

        public Criteria andIsOverseasEqualTo(Boolean value) {
            addCriterion("is_overseas =", value, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasNotEqualTo(Boolean value) {
            addCriterion("is_overseas <>", value, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasGreaterThan(Boolean value) {
            addCriterion("is_overseas >", value, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_overseas >=", value, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasLessThan(Boolean value) {
            addCriterion("is_overseas <", value, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasLessThanOrEqualTo(Boolean value) {
            addCriterion("is_overseas <=", value, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasIn(List<Boolean> values) {
            addCriterion("is_overseas in", values, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasNotIn(List<Boolean> values) {
            addCriterion("is_overseas not in", values, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasBetween(Boolean value1, Boolean value2) {
            addCriterion("is_overseas between", value1, value2, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsOverseasNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_overseas not between", value1, value2, "isOverseas");
            return (Criteria) this;
        }

        public Criteria andIsLiquidIsNull() {
            addCriterion("is_liquid is null");
            return (Criteria) this;
        }

        public Criteria andIsLiquidIsNotNull() {
            addCriterion("is_liquid is not null");
            return (Criteria) this;
        }

        public Criteria andIsLiquidEqualTo(Boolean value) {
            addCriterion("is_liquid =", value, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidNotEqualTo(Boolean value) {
            addCriterion("is_liquid <>", value, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidGreaterThan(Boolean value) {
            addCriterion("is_liquid >", value, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_liquid >=", value, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidLessThan(Boolean value) {
            addCriterion("is_liquid <", value, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidLessThanOrEqualTo(Boolean value) {
            addCriterion("is_liquid <=", value, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidIn(List<Boolean> values) {
            addCriterion("is_liquid in", values, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidNotIn(List<Boolean> values) {
            addCriterion("is_liquid not in", values, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidBetween(Boolean value1, Boolean value2) {
            addCriterion("is_liquid between", value1, value2, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIsLiquidNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_liquid not between", value1, value2, "isLiquid");
            return (Criteria) this;
        }

        public Criteria andIs3cProductIsNull() {
            addCriterion("is_3C_product is null");
            return (Criteria) this;
        }

        public Criteria andIs3cProductIsNotNull() {
            addCriterion("is_3C_product is not null");
            return (Criteria) this;
        }

        public Criteria andIs3cProductEqualTo(Boolean value) {
            addCriterion("is_3C_product =", value, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductNotEqualTo(Boolean value) {
            addCriterion("is_3C_product <>", value, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductGreaterThan(Boolean value) {
            addCriterion("is_3C_product >", value, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_3C_product >=", value, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductLessThan(Boolean value) {
            addCriterion("is_3C_product <", value, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductLessThanOrEqualTo(Boolean value) {
            addCriterion("is_3C_product <=", value, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductIn(List<Boolean> values) {
            addCriterion("is_3C_product in", values, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductNotIn(List<Boolean> values) {
            addCriterion("is_3C_product not in", values, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductBetween(Boolean value1, Boolean value2) {
            addCriterion("is_3C_product between", value1, value2, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIs3cProductNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_3C_product not between", value1, value2, "is3cProduct");
            return (Criteria) this;
        }

        public Criteria andIsBrittleIsNull() {
            addCriterion("is_brittle is null");
            return (Criteria) this;
        }

        public Criteria andIsBrittleIsNotNull() {
            addCriterion("is_brittle is not null");
            return (Criteria) this;
        }

        public Criteria andIsBrittleEqualTo(Boolean value) {
            addCriterion("is_brittle =", value, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleNotEqualTo(Boolean value) {
            addCriterion("is_brittle <>", value, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleGreaterThan(Boolean value) {
            addCriterion("is_brittle >", value, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_brittle >=", value, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleLessThan(Boolean value) {
            addCriterion("is_brittle <", value, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleLessThanOrEqualTo(Boolean value) {
            addCriterion("is_brittle <=", value, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleIn(List<Boolean> values) {
            addCriterion("is_brittle in", values, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleNotIn(List<Boolean> values) {
            addCriterion("is_brittle not in", values, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleBetween(Boolean value1, Boolean value2) {
            addCriterion("is_brittle between", value1, value2, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andIsBrittleNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_brittle not between", value1, value2, "isBrittle");
            return (Criteria) this;
        }

        public Criteria andDetailIsNull() {
            addCriterion("detail is null");
            return (Criteria) this;
        }

        public Criteria andDetailIsNotNull() {
            addCriterion("detail is not null");
            return (Criteria) this;
        }

        public Criteria andDetailEqualTo(String value) {
            addCriterion("detail =", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailNotEqualTo(String value) {
            addCriterion("detail <>", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailGreaterThan(String value) {
            addCriterion("detail >", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailGreaterThanOrEqualTo(String value) {
            addCriterion("detail >=", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailLessThan(String value) {
            addCriterion("detail <", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailLessThanOrEqualTo(String value) {
            addCriterion("detail <=", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailLike(String value) {
            addCriterion("detail like", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailNotLike(String value) {
            addCriterion("detail not like", value, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailIn(List<String> values) {
            addCriterion("detail in", values, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailNotIn(List<String> values) {
            addCriterion("detail not in", values, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailBetween(String value1, String value2) {
            addCriterion("detail between", value1, value2, "detail");
            return (Criteria) this;
        }

        public Criteria andDetailNotBetween(String value1, String value2) {
            addCriterion("detail not between", value1, value2, "detail");
            return (Criteria) this;
        }

        public Criteria andSaleUnitIsNull() {
            addCriterion("sale_unit is null");
            return (Criteria) this;
        }

        public Criteria andSaleUnitIsNotNull() {
            addCriterion("sale_unit is not null");
            return (Criteria) this;
        }

        public Criteria andSaleUnitEqualTo(String value) {
            addCriterion("sale_unit =", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitNotEqualTo(String value) {
            addCriterion("sale_unit <>", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitGreaterThan(String value) {
            addCriterion("sale_unit >", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitGreaterThanOrEqualTo(String value) {
            addCriterion("sale_unit >=", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitLessThan(String value) {
            addCriterion("sale_unit <", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitLessThanOrEqualTo(String value) {
            addCriterion("sale_unit <=", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitLike(String value) {
            addCriterion("sale_unit like", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitNotLike(String value) {
            addCriterion("sale_unit not like", value, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitIn(List<String> values) {
            addCriterion("sale_unit in", values, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitNotIn(List<String> values) {
            addCriterion("sale_unit not in", values, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitBetween(String value1, String value2) {
            addCriterion("sale_unit between", value1, value2, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andSaleUnitNotBetween(String value1, String value2) {
            addCriterion("sale_unit not between", value1, value2, "saleUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitIsNull() {
            addCriterion("stock_unit is null");
            return (Criteria) this;
        }

        public Criteria andStockUnitIsNotNull() {
            addCriterion("stock_unit is not null");
            return (Criteria) this;
        }

        public Criteria andStockUnitEqualTo(String value) {
            addCriterion("stock_unit =", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitNotEqualTo(String value) {
            addCriterion("stock_unit <>", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitGreaterThan(String value) {
            addCriterion("stock_unit >", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitGreaterThanOrEqualTo(String value) {
            addCriterion("stock_unit >=", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitLessThan(String value) {
            addCriterion("stock_unit <", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitLessThanOrEqualTo(String value) {
            addCriterion("stock_unit <=", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitLike(String value) {
            addCriterion("stock_unit like", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitNotLike(String value) {
            addCriterion("stock_unit not like", value, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitIn(List<String> values) {
            addCriterion("stock_unit in", values, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitNotIn(List<String> values) {
            addCriterion("stock_unit not in", values, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitBetween(String value1, String value2) {
            addCriterion("stock_unit between", value1, value2, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andStockUnitNotBetween(String value1, String value2) {
            addCriterion("stock_unit not between", value1, value2, "stockUnit");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxIsNull() {
            addCriterion("is_purchase_by_box is null");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxIsNotNull() {
            addCriterion("is_purchase_by_box is not null");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxEqualTo(Boolean value) {
            addCriterion("is_purchase_by_box =", value, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxNotEqualTo(Boolean value) {
            addCriterion("is_purchase_by_box <>", value, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxGreaterThan(Boolean value) {
            addCriterion("is_purchase_by_box >", value, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_purchase_by_box >=", value, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxLessThan(Boolean value) {
            addCriterion("is_purchase_by_box <", value, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxLessThanOrEqualTo(Boolean value) {
            addCriterion("is_purchase_by_box <=", value, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxIn(List<Boolean> values) {
            addCriterion("is_purchase_by_box in", values, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxNotIn(List<Boolean> values) {
            addCriterion("is_purchase_by_box not in", values, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxBetween(Boolean value1, Boolean value2) {
            addCriterion("is_purchase_by_box between", value1, value2, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andIsPurchaseByBoxNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_purchase_by_box not between", value1, value2, "isPurchaseByBox");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightIsNull() {
            addCriterion("single_gross_weight is null");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightIsNotNull() {
            addCriterion("single_gross_weight is not null");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightEqualTo(Integer value) {
            addCriterion("single_gross_weight =", value, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightNotEqualTo(Integer value) {
            addCriterion("single_gross_weight <>", value, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightGreaterThan(Integer value) {
            addCriterion("single_gross_weight >", value, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_gross_weight >=", value, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightLessThan(Integer value) {
            addCriterion("single_gross_weight <", value, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightLessThanOrEqualTo(Integer value) {
            addCriterion("single_gross_weight <=", value, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightIn(List<Integer> values) {
            addCriterion("single_gross_weight in", values, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightNotIn(List<Integer> values) {
            addCriterion("single_gross_weight not in", values, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightBetween(Integer value1, Integer value2) {
            addCriterion("single_gross_weight between", value1, value2, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleGrossWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("single_gross_weight not between", value1, value2, "singleGrossWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightIsNull() {
            addCriterion("single_net_weight is null");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightIsNotNull() {
            addCriterion("single_net_weight is not null");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightEqualTo(Integer value) {
            addCriterion("single_net_weight =", value, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightNotEqualTo(Integer value) {
            addCriterion("single_net_weight <>", value, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightGreaterThan(Integer value) {
            addCriterion("single_net_weight >", value, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_net_weight >=", value, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightLessThan(Integer value) {
            addCriterion("single_net_weight <", value, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightLessThanOrEqualTo(Integer value) {
            addCriterion("single_net_weight <=", value, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightIn(List<Integer> values) {
            addCriterion("single_net_weight in", values, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightNotIn(List<Integer> values) {
            addCriterion("single_net_weight not in", values, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightBetween(Integer value1, Integer value2) {
            addCriterion("single_net_weight between", value1, value2, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleNetWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("single_net_weight not between", value1, value2, "singleNetWeight");
            return (Criteria) this;
        }

        public Criteria andSingleLengthIsNull() {
            addCriterion("single_length is null");
            return (Criteria) this;
        }

        public Criteria andSingleLengthIsNotNull() {
            addCriterion("single_length is not null");
            return (Criteria) this;
        }

        public Criteria andSingleLengthEqualTo(Integer value) {
            addCriterion("single_length =", value, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthNotEqualTo(Integer value) {
            addCriterion("single_length <>", value, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthGreaterThan(Integer value) {
            addCriterion("single_length >", value, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_length >=", value, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthLessThan(Integer value) {
            addCriterion("single_length <", value, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthLessThanOrEqualTo(Integer value) {
            addCriterion("single_length <=", value, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthIn(List<Integer> values) {
            addCriterion("single_length in", values, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthNotIn(List<Integer> values) {
            addCriterion("single_length not in", values, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthBetween(Integer value1, Integer value2) {
            addCriterion("single_length between", value1, value2, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleLengthNotBetween(Integer value1, Integer value2) {
            addCriterion("single_length not between", value1, value2, "singleLength");
            return (Criteria) this;
        }

        public Criteria andSingleWidthIsNull() {
            addCriterion("single_width is null");
            return (Criteria) this;
        }

        public Criteria andSingleWidthIsNotNull() {
            addCriterion("single_width is not null");
            return (Criteria) this;
        }

        public Criteria andSingleWidthEqualTo(Integer value) {
            addCriterion("single_width =", value, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthNotEqualTo(Integer value) {
            addCriterion("single_width <>", value, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthGreaterThan(Integer value) {
            addCriterion("single_width >", value, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_width >=", value, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthLessThan(Integer value) {
            addCriterion("single_width <", value, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthLessThanOrEqualTo(Integer value) {
            addCriterion("single_width <=", value, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthIn(List<Integer> values) {
            addCriterion("single_width in", values, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthNotIn(List<Integer> values) {
            addCriterion("single_width not in", values, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthBetween(Integer value1, Integer value2) {
            addCriterion("single_width between", value1, value2, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleWidthNotBetween(Integer value1, Integer value2) {
            addCriterion("single_width not between", value1, value2, "singleWidth");
            return (Criteria) this;
        }

        public Criteria andSingleHeightIsNull() {
            addCriterion("single_height is null");
            return (Criteria) this;
        }

        public Criteria andSingleHeightIsNotNull() {
            addCriterion("single_height is not null");
            return (Criteria) this;
        }

        public Criteria andSingleHeightEqualTo(Integer value) {
            addCriterion("single_height =", value, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightNotEqualTo(Integer value) {
            addCriterion("single_height <>", value, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightGreaterThan(Integer value) {
            addCriterion("single_height >", value, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("single_height >=", value, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightLessThan(Integer value) {
            addCriterion("single_height <", value, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightLessThanOrEqualTo(Integer value) {
            addCriterion("single_height <=", value, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightIn(List<Integer> values) {
            addCriterion("single_height in", values, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightNotIn(List<Integer> values) {
            addCriterion("single_height not in", values, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightBetween(Integer value1, Integer value2) {
            addCriterion("single_height between", value1, value2, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andSingleHeightNotBetween(Integer value1, Integer value2) {
            addCriterion("single_height not between", value1, value2, "singleHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightIsNull() {
            addCriterion("original_box_gross_weight is null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightIsNotNull() {
            addCriterion("original_box_gross_weight is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightEqualTo(Integer value) {
            addCriterion("original_box_gross_weight =", value, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightNotEqualTo(Integer value) {
            addCriterion("original_box_gross_weight <>", value, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightGreaterThan(Integer value) {
            addCriterion("original_box_gross_weight >", value, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("original_box_gross_weight >=", value, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightLessThan(Integer value) {
            addCriterion("original_box_gross_weight <", value, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightLessThanOrEqualTo(Integer value) {
            addCriterion("original_box_gross_weight <=", value, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightIn(List<Integer> values) {
            addCriterion("original_box_gross_weight in", values, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightNotIn(List<Integer> values) {
            addCriterion("original_box_gross_weight not in", values, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightBetween(Integer value1, Integer value2) {
            addCriterion("original_box_gross_weight between", value1, value2, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxGrossWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("original_box_gross_weight not between", value1, value2, "originalBoxGrossWeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthIsNull() {
            addCriterion("original_box_length is null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthIsNotNull() {
            addCriterion("original_box_length is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthEqualTo(Integer value) {
            addCriterion("original_box_length =", value, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthNotEqualTo(Integer value) {
            addCriterion("original_box_length <>", value, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthGreaterThan(Integer value) {
            addCriterion("original_box_length >", value, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthGreaterThanOrEqualTo(Integer value) {
            addCriterion("original_box_length >=", value, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthLessThan(Integer value) {
            addCriterion("original_box_length <", value, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthLessThanOrEqualTo(Integer value) {
            addCriterion("original_box_length <=", value, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthIn(List<Integer> values) {
            addCriterion("original_box_length in", values, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthNotIn(List<Integer> values) {
            addCriterion("original_box_length not in", values, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthBetween(Integer value1, Integer value2) {
            addCriterion("original_box_length between", value1, value2, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxLengthNotBetween(Integer value1, Integer value2) {
            addCriterion("original_box_length not between", value1, value2, "originalBoxLength");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthIsNull() {
            addCriterion("original_box_width is null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthIsNotNull() {
            addCriterion("original_box_width is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthEqualTo(Integer value) {
            addCriterion("original_box_width =", value, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthNotEqualTo(Integer value) {
            addCriterion("original_box_width <>", value, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthGreaterThan(Integer value) {
            addCriterion("original_box_width >", value, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthGreaterThanOrEqualTo(Integer value) {
            addCriterion("original_box_width >=", value, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthLessThan(Integer value) {
            addCriterion("original_box_width <", value, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthLessThanOrEqualTo(Integer value) {
            addCriterion("original_box_width <=", value, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthIn(List<Integer> values) {
            addCriterion("original_box_width in", values, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthNotIn(List<Integer> values) {
            addCriterion("original_box_width not in", values, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthBetween(Integer value1, Integer value2) {
            addCriterion("original_box_width between", value1, value2, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxWidthNotBetween(Integer value1, Integer value2) {
            addCriterion("original_box_width not between", value1, value2, "originalBoxWidth");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightIsNull() {
            addCriterion("original_box_height is null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightIsNotNull() {
            addCriterion("original_box_height is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightEqualTo(Integer value) {
            addCriterion("original_box_height =", value, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightNotEqualTo(Integer value) {
            addCriterion("original_box_height <>", value, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightGreaterThan(Integer value) {
            addCriterion("original_box_height >", value, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("original_box_height >=", value, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightLessThan(Integer value) {
            addCriterion("original_box_height <", value, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightLessThanOrEqualTo(Integer value) {
            addCriterion("original_box_height <=", value, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightIn(List<Integer> values) {
            addCriterion("original_box_height in", values, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightNotIn(List<Integer> values) {
            addCriterion("original_box_height not in", values, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightBetween(Integer value1, Integer value2) {
            addCriterion("original_box_height between", value1, value2, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andOriginalBoxHeightNotBetween(Integer value1, Integer value2) {
            addCriterion("original_box_height not between", value1, value2, "originalBoxHeight");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityIsNull() {
            addCriterion("package_quantity is null");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityIsNotNull() {
            addCriterion("package_quantity is not null");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityEqualTo(Integer value) {
            addCriterion("package_quantity =", value, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityNotEqualTo(Integer value) {
            addCriterion("package_quantity <>", value, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityGreaterThan(Integer value) {
            addCriterion("package_quantity >", value, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityGreaterThanOrEqualTo(Integer value) {
            addCriterion("package_quantity >=", value, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityLessThan(Integer value) {
            addCriterion("package_quantity <", value, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityLessThanOrEqualTo(Integer value) {
            addCriterion("package_quantity <=", value, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityIn(List<Integer> values) {
            addCriterion("package_quantity in", values, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityNotIn(List<Integer> values) {
            addCriterion("package_quantity not in", values, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityBetween(Integer value1, Integer value2) {
            addCriterion("package_quantity between", value1, value2, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageQuantityNotBetween(Integer value1, Integer value2) {
            addCriterion("package_quantity not between", value1, value2, "packageQuantity");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialIsNull() {
            addCriterion("package_material is null");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialIsNotNull() {
            addCriterion("package_material is not null");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialEqualTo(String value) {
            addCriterion("package_material =", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialNotEqualTo(String value) {
            addCriterion("package_material <>", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialGreaterThan(String value) {
            addCriterion("package_material >", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("package_material >=", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialLessThan(String value) {
            addCriterion("package_material <", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialLessThanOrEqualTo(String value) {
            addCriterion("package_material <=", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialLike(String value) {
            addCriterion("package_material like", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialNotLike(String value) {
            addCriterion("package_material not like", value, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialIn(List<String> values) {
            addCriterion("package_material in", values, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialNotIn(List<String> values) {
            addCriterion("package_material not in", values, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialBetween(String value1, String value2) {
            addCriterion("package_material between", value1, value2, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageMaterialNotBetween(String value1, String value2) {
            addCriterion("package_material not between", value1, value2, "packageMaterial");
            return (Criteria) this;
        }

        public Criteria andPackageListIsNull() {
            addCriterion("package_list is null");
            return (Criteria) this;
        }

        public Criteria andPackageListIsNotNull() {
            addCriterion("package_list is not null");
            return (Criteria) this;
        }

        public Criteria andPackageListEqualTo(String value) {
            addCriterion("package_list =", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListNotEqualTo(String value) {
            addCriterion("package_list <>", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListGreaterThan(String value) {
            addCriterion("package_list >", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListGreaterThanOrEqualTo(String value) {
            addCriterion("package_list >=", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListLessThan(String value) {
            addCriterion("package_list <", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListLessThanOrEqualTo(String value) {
            addCriterion("package_list <=", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListLike(String value) {
            addCriterion("package_list like", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListNotLike(String value) {
            addCriterion("package_list not like", value, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListIn(List<String> values) {
            addCriterion("package_list in", values, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListNotIn(List<String> values) {
            addCriterion("package_list not in", values, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListBetween(String value1, String value2) {
            addCriterion("package_list between", value1, value2, "packageList");
            return (Criteria) this;
        }

        public Criteria andPackageListNotBetween(String value1, String value2) {
            addCriterion("package_list not between", value1, value2, "packageList");
            return (Criteria) this;
        }

        public Criteria andStoreConditionIsNull() {
            addCriterion("store_condition is null");
            return (Criteria) this;
        }

        public Criteria andStoreConditionIsNotNull() {
            addCriterion("store_condition is not null");
            return (Criteria) this;
        }

        public Criteria andStoreConditionEqualTo(Integer value) {
            addCriterion("store_condition =", value, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionNotEqualTo(Integer value) {
            addCriterion("store_condition <>", value, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionGreaterThan(Integer value) {
            addCriterion("store_condition >", value, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionGreaterThanOrEqualTo(Integer value) {
            addCriterion("store_condition >=", value, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionLessThan(Integer value) {
            addCriterion("store_condition <", value, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionLessThanOrEqualTo(Integer value) {
            addCriterion("store_condition <=", value, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionIn(List<Integer> values) {
            addCriterion("store_condition in", values, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionNotIn(List<Integer> values) {
            addCriterion("store_condition not in", values, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionBetween(Integer value1, Integer value2) {
            addCriterion("store_condition between", value1, value2, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionNotBetween(Integer value1, Integer value2) {
            addCriterion("store_condition not between", value1, value2, "storeCondition");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailIsNull() {
            addCriterion("store_condition_detail is null");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailIsNotNull() {
            addCriterion("store_condition_detail is not null");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailEqualTo(String value) {
            addCriterion("store_condition_detail =", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailNotEqualTo(String value) {
            addCriterion("store_condition_detail <>", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailGreaterThan(String value) {
            addCriterion("store_condition_detail >", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailGreaterThanOrEqualTo(String value) {
            addCriterion("store_condition_detail >=", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailLessThan(String value) {
            addCriterion("store_condition_detail <", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailLessThanOrEqualTo(String value) {
            addCriterion("store_condition_detail <=", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailLike(String value) {
            addCriterion("store_condition_detail like", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailNotLike(String value) {
            addCriterion("store_condition_detail not like", value, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailIn(List<String> values) {
            addCriterion("store_condition_detail in", values, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailNotIn(List<String> values) {
            addCriterion("store_condition_detail not in", values, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailBetween(String value1, String value2) {
            addCriterion("store_condition_detail between", value1, value2, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStoreConditionDetailNotBetween(String value1, String value2) {
            addCriterion("store_condition_detail not between", value1, value2, "storeConditionDetail");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreatorIsNull() {
            addCriterion("creator is null");
            return (Criteria) this;
        }

        public Criteria andCreatorIsNotNull() {
            addCriterion("creator is not null");
            return (Criteria) this;
        }

        public Criteria andCreatorEqualTo(Integer value) {
            addCriterion("creator =", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotEqualTo(Integer value) {
            addCriterion("creator <>", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorGreaterThan(Integer value) {
            addCriterion("creator >", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorGreaterThanOrEqualTo(Integer value) {
            addCriterion("creator >=", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLessThan(Integer value) {
            addCriterion("creator <", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLessThanOrEqualTo(Integer value) {
            addCriterion("creator <=", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorIn(List<Integer> values) {
            addCriterion("creator in", values, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotIn(List<Integer> values) {
            addCriterion("creator not in", values, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorBetween(Integer value1, Integer value2) {
            addCriterion("creator between", value1, value2, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotBetween(Integer value1, Integer value2) {
            addCriterion("creator not between", value1, value2, "creator");
            return (Criteria) this;
        }

        public Criteria andModifierIsNull() {
            addCriterion("modifier is null");
            return (Criteria) this;
        }

        public Criteria andModifierIsNotNull() {
            addCriterion("modifier is not null");
            return (Criteria) this;
        }

        public Criteria andModifierEqualTo(Integer value) {
            addCriterion("modifier =", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotEqualTo(Integer value) {
            addCriterion("modifier <>", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierGreaterThan(Integer value) {
            addCriterion("modifier >", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierGreaterThanOrEqualTo(Integer value) {
            addCriterion("modifier >=", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLessThan(Integer value) {
            addCriterion("modifier <", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLessThanOrEqualTo(Integer value) {
            addCriterion("modifier <=", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierIn(List<Integer> values) {
            addCriterion("modifier in", values, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotIn(List<Integer> values) {
            addCriterion("modifier not in", values, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierBetween(Integer value1, Integer value2) {
            addCriterion("modifier between", value1, value2, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotBetween(Integer value1, Integer value2) {
            addCriterion("modifier not between", value1, value2, "modifier");
            return (Criteria) this;
        }

        public Criteria andCreatedAtIsNull() {
            addCriterion("created_at is null");
            return (Criteria) this;
        }

        public Criteria andCreatedAtIsNotNull() {
            addCriterion("created_at is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedAtEqualTo(Date value) {
            addCriterion("created_at =", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotEqualTo(Date value) {
            addCriterion("created_at <>", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtGreaterThan(Date value) {
            addCriterion("created_at >", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtGreaterThanOrEqualTo(Date value) {
            addCriterion("created_at >=", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtLessThan(Date value) {
            addCriterion("created_at <", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtLessThanOrEqualTo(Date value) {
            addCriterion("created_at <=", value, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtIn(List<Date> values) {
            addCriterion("created_at in", values, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotIn(List<Date> values) {
            addCriterion("created_at not in", values, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtBetween(Date value1, Date value2) {
            addCriterion("created_at between", value1, value2, "createdAt");
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotBetween(Date value1, Date value2) {
            addCriterion("created_at not between", value1, value2, "createdAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtIsNull() {
            addCriterion("updated_at is null");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtIsNotNull() {
            addCriterion("updated_at is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtEqualTo(Date value) {
            addCriterion("updated_at =", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotEqualTo(Date value) {
            addCriterion("updated_at <>", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtGreaterThan(Date value) {
            addCriterion("updated_at >", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtGreaterThanOrEqualTo(Date value) {
            addCriterion("updated_at >=", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtLessThan(Date value) {
            addCriterion("updated_at <", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtLessThanOrEqualTo(Date value) {
            addCriterion("updated_at <=", value, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtIn(List<Date> values) {
            addCriterion("updated_at in", values, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotIn(List<Date> values) {
            addCriterion("updated_at not in", values, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtBetween(Date value1, Date value2) {
            addCriterion("updated_at between", value1, value2, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotBetween(Date value1, Date value2) {
            addCriterion("updated_at not between", value1, value2, "updatedAt");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnIsNull() {
            addCriterion("is_sales_return is null");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnIsNotNull() {
            addCriterion("is_sales_return is not null");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnEqualTo(Boolean value) {
            addCriterion("is_sales_return =", value, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnNotEqualTo(Boolean value) {
            addCriterion("is_sales_return <>", value, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnGreaterThan(Boolean value) {
            addCriterion("is_sales_return >", value, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_sales_return >=", value, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnLessThan(Boolean value) {
            addCriterion("is_sales_return <", value, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnLessThanOrEqualTo(Boolean value) {
            addCriterion("is_sales_return <=", value, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnIn(List<Boolean> values) {
            addCriterion("is_sales_return in", values, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnNotIn(List<Boolean> values) {
            addCriterion("is_sales_return not in", values, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnBetween(Boolean value1, Boolean value2) {
            addCriterion("is_sales_return between", value1, value2, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andIsSalesReturnNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_sales_return not between", value1, value2, "isSalesReturn");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateIsNull() {
            addCriterion("sales_return_rate is null");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateIsNotNull() {
            addCriterion("sales_return_rate is not null");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateEqualTo(BigDecimal value) {
            addCriterion("sales_return_rate =", value, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateNotEqualTo(BigDecimal value) {
            addCriterion("sales_return_rate <>", value, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateGreaterThan(BigDecimal value) {
            addCriterion("sales_return_rate >", value, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("sales_return_rate >=", value, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateLessThan(BigDecimal value) {
            addCriterion("sales_return_rate <", value, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("sales_return_rate <=", value, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateIn(List<BigDecimal> values) {
            addCriterion("sales_return_rate in", values, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateNotIn(List<BigDecimal> values) {
            addCriterion("sales_return_rate not in", values, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sales_return_rate between", value1, value2, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andSalesReturnRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sales_return_rate not between", value1, value2, "salesReturnRate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateIsNull() {
            addCriterion("phytosanitary_certificate is null");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateIsNotNull() {
            addCriterion("phytosanitary_certificate is not null");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateEqualTo(String value) {
            addCriterion("phytosanitary_certificate =", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateNotEqualTo(String value) {
            addCriterion("phytosanitary_certificate <>", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateGreaterThan(String value) {
            addCriterion("phytosanitary_certificate >", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateGreaterThanOrEqualTo(String value) {
            addCriterion("phytosanitary_certificate >=", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateLessThan(String value) {
            addCriterion("phytosanitary_certificate <", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateLessThanOrEqualTo(String value) {
            addCriterion("phytosanitary_certificate <=", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateLike(String value) {
            addCriterion("phytosanitary_certificate like", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateNotLike(String value) {
            addCriterion("phytosanitary_certificate not like", value, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateIn(List<String> values) {
            addCriterion("phytosanitary_certificate in", values, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateNotIn(List<String> values) {
            addCriterion("phytosanitary_certificate not in", values, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateBetween(String value1, String value2) {
            addCriterion("phytosanitary_certificate between", value1, value2, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andPhytosanitaryCertificateNotBetween(String value1, String value2) {
            addCriterion("phytosanitary_certificate not between", value1, value2, "phytosanitaryCertificate");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormIsNull() {
            addCriterion("declaration_form is null");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormIsNotNull() {
            addCriterion("declaration_form is not null");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormEqualTo(String value) {
            addCriterion("declaration_form =", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormNotEqualTo(String value) {
            addCriterion("declaration_form <>", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormGreaterThan(String value) {
            addCriterion("declaration_form >", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormGreaterThanOrEqualTo(String value) {
            addCriterion("declaration_form >=", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormLessThan(String value) {
            addCriterion("declaration_form <", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormLessThanOrEqualTo(String value) {
            addCriterion("declaration_form <=", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormLike(String value) {
            addCriterion("declaration_form like", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormNotLike(String value) {
            addCriterion("declaration_form not like", value, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormIn(List<String> values) {
            addCriterion("declaration_form in", values, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormNotIn(List<String> values) {
            addCriterion("declaration_form not in", values, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormBetween(String value1, String value2) {
            addCriterion("declaration_form between", value1, value2, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andDeclarationFormNotBetween(String value1, String value2) {
            addCriterion("declaration_form not between", value1, value2, "declarationForm");
            return (Criteria) this;
        }

        public Criteria andQcReportIsNull() {
            addCriterion("qc_report is null");
            return (Criteria) this;
        }

        public Criteria andQcReportIsNotNull() {
            addCriterion("qc_report is not null");
            return (Criteria) this;
        }

        public Criteria andQcReportEqualTo(String value) {
            addCriterion("qc_report =", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportNotEqualTo(String value) {
            addCriterion("qc_report <>", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportGreaterThan(String value) {
            addCriterion("qc_report >", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportGreaterThanOrEqualTo(String value) {
            addCriterion("qc_report >=", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportLessThan(String value) {
            addCriterion("qc_report <", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportLessThanOrEqualTo(String value) {
            addCriterion("qc_report <=", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportLike(String value) {
            addCriterion("qc_report like", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportNotLike(String value) {
            addCriterion("qc_report not like", value, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportIn(List<String> values) {
            addCriterion("qc_report in", values, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportNotIn(List<String> values) {
            addCriterion("qc_report not in", values, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportBetween(String value1, String value2) {
            addCriterion("qc_report between", value1, value2, "qcReport");
            return (Criteria) this;
        }

        public Criteria andQcReportNotBetween(String value1, String value2) {
            addCriterion("qc_report not between", value1, value2, "qcReport");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseIsNull() {
            addCriterion("manufactor_business_license is null");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseIsNotNull() {
            addCriterion("manufactor_business_license is not null");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseEqualTo(String value) {
            addCriterion("manufactor_business_license =", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseNotEqualTo(String value) {
            addCriterion("manufactor_business_license <>", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseGreaterThan(String value) {
            addCriterion("manufactor_business_license >", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseGreaterThanOrEqualTo(String value) {
            addCriterion("manufactor_business_license >=", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseLessThan(String value) {
            addCriterion("manufactor_business_license <", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseLessThanOrEqualTo(String value) {
            addCriterion("manufactor_business_license <=", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseLike(String value) {
            addCriterion("manufactor_business_license like", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseNotLike(String value) {
            addCriterion("manufactor_business_license not like", value, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseIn(List<String> values) {
            addCriterion("manufactor_business_license in", values, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseNotIn(List<String> values) {
            addCriterion("manufactor_business_license not in", values, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseBetween(String value1, String value2) {
            addCriterion("manufactor_business_license between", value1, value2, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andManufactorBusinessLicenseNotBetween(String value1, String value2) {
            addCriterion("manufactor_business_license not between", value1, value2, "manufactorBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseIsNull() {
            addCriterion("importer_business_license is null");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseIsNotNull() {
            addCriterion("importer_business_license is not null");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseEqualTo(String value) {
            addCriterion("importer_business_license =", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseNotEqualTo(String value) {
            addCriterion("importer_business_license <>", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseGreaterThan(String value) {
            addCriterion("importer_business_license >", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseGreaterThanOrEqualTo(String value) {
            addCriterion("importer_business_license >=", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseLessThan(String value) {
            addCriterion("importer_business_license <", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseLessThanOrEqualTo(String value) {
            addCriterion("importer_business_license <=", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseLike(String value) {
            addCriterion("importer_business_license like", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseNotLike(String value) {
            addCriterion("importer_business_license not like", value, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseIn(List<String> values) {
            addCriterion("importer_business_license in", values, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseNotIn(List<String> values) {
            addCriterion("importer_business_license not in", values, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseBetween(String value1, String value2) {
            addCriterion("importer_business_license between", value1, value2, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andImporterBusinessLicenseNotBetween(String value1, String value2) {
            addCriterion("importer_business_license not between", value1, value2, "importerBusinessLicense");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeIsNull() {
            addCriterion("supply_start_time is null");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeIsNotNull() {
            addCriterion("supply_start_time is not null");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeEqualTo(String value) {
            addCriterion("supply_start_time =", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeNotEqualTo(String value) {
            addCriterion("supply_start_time <>", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeGreaterThan(String value) {
            addCriterion("supply_start_time >", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeGreaterThanOrEqualTo(String value) {
            addCriterion("supply_start_time >=", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeLessThan(String value) {
            addCriterion("supply_start_time <", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeLessThanOrEqualTo(String value) {
            addCriterion("supply_start_time <=", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeLike(String value) {
            addCriterion("supply_start_time like", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeNotLike(String value) {
            addCriterion("supply_start_time not like", value, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeIn(List<String> values) {
            addCriterion("supply_start_time in", values, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeNotIn(List<String> values) {
            addCriterion("supply_start_time not in", values, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeBetween(String value1, String value2) {
            addCriterion("supply_start_time between", value1, value2, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyStartTimeNotBetween(String value1, String value2) {
            addCriterion("supply_start_time not between", value1, value2, "supplyStartTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeIsNull() {
            addCriterion("supply_end_time is null");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeIsNotNull() {
            addCriterion("supply_end_time is not null");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeEqualTo(String value) {
            addCriterion("supply_end_time =", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeNotEqualTo(String value) {
            addCriterion("supply_end_time <>", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeGreaterThan(String value) {
            addCriterion("supply_end_time >", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeGreaterThanOrEqualTo(String value) {
            addCriterion("supply_end_time >=", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeLessThan(String value) {
            addCriterion("supply_end_time <", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeLessThanOrEqualTo(String value) {
            addCriterion("supply_end_time <=", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeLike(String value) {
            addCriterion("supply_end_time like", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeNotLike(String value) {
            addCriterion("supply_end_time not like", value, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeIn(List<String> values) {
            addCriterion("supply_end_time in", values, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeNotIn(List<String> values) {
            addCriterion("supply_end_time not in", values, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeBetween(String value1, String value2) {
            addCriterion("supply_end_time between", value1, value2, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andSupplyEndTimeNotBetween(String value1, String value2) {
            addCriterion("supply_end_time not between", value1, value2, "supplyEndTime");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeIsNull() {
            addCriterion("purchase_tax_code is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeIsNotNull() {
            addCriterion("purchase_tax_code is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeEqualTo(String value) {
            addCriterion("purchase_tax_code =", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeNotEqualTo(String value) {
            addCriterion("purchase_tax_code <>", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeGreaterThan(String value) {
            addCriterion("purchase_tax_code >", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_tax_code >=", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeLessThan(String value) {
            addCriterion("purchase_tax_code <", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeLessThanOrEqualTo(String value) {
            addCriterion("purchase_tax_code <=", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeLike(String value) {
            addCriterion("purchase_tax_code like", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeNotLike(String value) {
            addCriterion("purchase_tax_code not like", value, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeIn(List<String> values) {
            addCriterion("purchase_tax_code in", values, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeNotIn(List<String> values) {
            addCriterion("purchase_tax_code not in", values, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeBetween(String value1, String value2) {
            addCriterion("purchase_tax_code between", value1, value2, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxCodeNotBetween(String value1, String value2) {
            addCriterion("purchase_tax_code not between", value1, value2, "purchaseTaxCode");
            return (Criteria) this;
        }

        public Criteria andSpuIdIsNull() {
            addCriterion("spu_id is null");
            return (Criteria) this;
        }

        public Criteria andSpuIdIsNotNull() {
            addCriterion("spu_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpuIdEqualTo(Long value) {
            addCriterion("spu_id =", value, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdNotEqualTo(Long value) {
            addCriterion("spu_id <>", value, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdGreaterThan(Long value) {
            addCriterion("spu_id >", value, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdGreaterThanOrEqualTo(Long value) {
            addCriterion("spu_id >=", value, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdLessThan(Long value) {
            addCriterion("spu_id <", value, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdLessThanOrEqualTo(Long value) {
            addCriterion("spu_id <=", value, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdIn(List<Long> values) {
            addCriterion("spu_id in", values, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdNotIn(List<Long> values) {
            addCriterion("spu_id not in", values, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdBetween(Long value1, Long value2) {
            addCriterion("spu_id between", value1, value2, "spuId");
            return (Criteria) this;
        }

        public Criteria andSpuIdNotBetween(Long value1, Long value2) {
            addCriterion("spu_id not between", value1, value2, "spuId");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleIsNull() {
            addCriterion("quantity_in_single is null");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleIsNotNull() {
            addCriterion("quantity_in_single is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleEqualTo(Integer value) {
            addCriterion("quantity_in_single =", value, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleNotEqualTo(Integer value) {
            addCriterion("quantity_in_single <>", value, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleGreaterThan(Integer value) {
            addCriterion("quantity_in_single >", value, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_in_single >=", value, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleLessThan(Integer value) {
            addCriterion("quantity_in_single <", value, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_in_single <=", value, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleIn(List<Integer> values) {
            addCriterion("quantity_in_single in", values, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleNotIn(List<Integer> values) {
            addCriterion("quantity_in_single not in", values, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleBetween(Integer value1, Integer value2) {
            addCriterion("quantity_in_single between", value1, value2, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andQuantityInSingleNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_in_single not between", value1, value2, "quantityInSingle");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdIsNull() {
            addCriterion("mall_spu_id is null");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdIsNotNull() {
            addCriterion("mall_spu_id is not null");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdEqualTo(Integer value) {
            addCriterion("mall_spu_id =", value, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdNotEqualTo(Integer value) {
            addCriterion("mall_spu_id <>", value, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdGreaterThan(Integer value) {
            addCriterion("mall_spu_id >", value, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("mall_spu_id >=", value, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdLessThan(Integer value) {
            addCriterion("mall_spu_id <", value, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdLessThanOrEqualTo(Integer value) {
            addCriterion("mall_spu_id <=", value, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdIn(List<Integer> values) {
            addCriterion("mall_spu_id in", values, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdNotIn(List<Integer> values) {
            addCriterion("mall_spu_id not in", values, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdBetween(Integer value1, Integer value2) {
            addCriterion("mall_spu_id between", value1, value2, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andMallSpuIdNotBetween(Integer value1, Integer value2) {
            addCriterion("mall_spu_id not between", value1, value2, "mallSpuId");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeIsNull() {
            addCriterion("prepare_cycle_type is null");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeIsNotNull() {
            addCriterion("prepare_cycle_type is not null");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeEqualTo(String value) {
            addCriterion("prepare_cycle_type =", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeNotEqualTo(String value) {
            addCriterion("prepare_cycle_type <>", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeGreaterThan(String value) {
            addCriterion("prepare_cycle_type >", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeGreaterThanOrEqualTo(String value) {
            addCriterion("prepare_cycle_type >=", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeLessThan(String value) {
            addCriterion("prepare_cycle_type <", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeLessThanOrEqualTo(String value) {
            addCriterion("prepare_cycle_type <=", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeLike(String value) {
            addCriterion("prepare_cycle_type like", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeNotLike(String value) {
            addCriterion("prepare_cycle_type not like", value, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeIn(List<String> values) {
            addCriterion("prepare_cycle_type in", values, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeNotIn(List<String> values) {
            addCriterion("prepare_cycle_type not in", values, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeBetween(String value1, String value2) {
            addCriterion("prepare_cycle_type between", value1, value2, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleTypeNotBetween(String value1, String value2) {
            addCriterion("prepare_cycle_type not between", value1, value2, "prepareCycleType");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueIsNull() {
            addCriterion("prepare_cycle_value is null");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueIsNotNull() {
            addCriterion("prepare_cycle_value is not null");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueEqualTo(Integer value) {
            addCriterion("prepare_cycle_value =", value, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueNotEqualTo(Integer value) {
            addCriterion("prepare_cycle_value <>", value, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueGreaterThan(Integer value) {
            addCriterion("prepare_cycle_value >", value, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueGreaterThanOrEqualTo(Integer value) {
            addCriterion("prepare_cycle_value >=", value, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueLessThan(Integer value) {
            addCriterion("prepare_cycle_value <", value, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueLessThanOrEqualTo(Integer value) {
            addCriterion("prepare_cycle_value <=", value, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueIn(List<Integer> values) {
            addCriterion("prepare_cycle_value in", values, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueNotIn(List<Integer> values) {
            addCriterion("prepare_cycle_value not in", values, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueBetween(Integer value1, Integer value2) {
            addCriterion("prepare_cycle_value between", value1, value2, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andPrepareCycleValueNotBetween(Integer value1, Integer value2) {
            addCriterion("prepare_cycle_value not between", value1, value2, "prepareCycleValue");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxIsNull() {
            addCriterion("quantity_in_box is null");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxIsNotNull() {
            addCriterion("quantity_in_box is not null");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxEqualTo(Integer value) {
            addCriterion("quantity_in_box =", value, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxNotEqualTo(Integer value) {
            addCriterion("quantity_in_box <>", value, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxGreaterThan(Integer value) {
            addCriterion("quantity_in_box >", value, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxGreaterThanOrEqualTo(Integer value) {
            addCriterion("quantity_in_box >=", value, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxLessThan(Integer value) {
            addCriterion("quantity_in_box <", value, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxLessThanOrEqualTo(Integer value) {
            addCriterion("quantity_in_box <=", value, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxIn(List<Integer> values) {
            addCriterion("quantity_in_box in", values, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxNotIn(List<Integer> values) {
            addCriterion("quantity_in_box not in", values, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxBetween(Integer value1, Integer value2) {
            addCriterion("quantity_in_box between", value1, value2, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andQuantityInBoxNotBetween(Integer value1, Integer value2) {
            addCriterion("quantity_in_box not between", value1, value2, "quantityInBox");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlIsNull() {
            addCriterion("brochure_url is null");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlIsNotNull() {
            addCriterion("brochure_url is not null");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlEqualTo(String value) {
            addCriterion("brochure_url =", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlNotEqualTo(String value) {
            addCriterion("brochure_url <>", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlGreaterThan(String value) {
            addCriterion("brochure_url >", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlGreaterThanOrEqualTo(String value) {
            addCriterion("brochure_url >=", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlLessThan(String value) {
            addCriterion("brochure_url <", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlLessThanOrEqualTo(String value) {
            addCriterion("brochure_url <=", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlLike(String value) {
            addCriterion("brochure_url like", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlNotLike(String value) {
            addCriterion("brochure_url not like", value, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlIn(List<String> values) {
            addCriterion("brochure_url in", values, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlNotIn(List<String> values) {
            addCriterion("brochure_url not in", values, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlBetween(String value1, String value2) {
            addCriterion("brochure_url between", value1, value2, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andBrochureUrlNotBetween(String value1, String value2) {
            addCriterion("brochure_url not between", value1, value2, "brochureUrl");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioIsNull() {
            addCriterion("purchase_tax_ratio is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioIsNotNull() {
            addCriterion("purchase_tax_ratio is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioEqualTo(BigDecimal value) {
            addCriterion("purchase_tax_ratio =", value, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioNotEqualTo(BigDecimal value) {
            addCriterion("purchase_tax_ratio <>", value, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioGreaterThan(BigDecimal value) {
            addCriterion("purchase_tax_ratio >", value, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("purchase_tax_ratio >=", value, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioLessThan(BigDecimal value) {
            addCriterion("purchase_tax_ratio <", value, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioLessThanOrEqualTo(BigDecimal value) {
            addCriterion("purchase_tax_ratio <=", value, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioIn(List<BigDecimal> values) {
            addCriterion("purchase_tax_ratio in", values, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioNotIn(List<BigDecimal> values) {
            addCriterion("purchase_tax_ratio not in", values, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("purchase_tax_ratio between", value1, value2, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andPurchaseTaxRatioNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("purchase_tax_ratio not between", value1, value2, "purchaseTaxRatio");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameIsNull() {
            addCriterion("supplier_spu_en_name is null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameIsNotNull() {
            addCriterion("supplier_spu_en_name is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameEqualTo(String value) {
            addCriterion("supplier_spu_en_name =", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameNotEqualTo(String value) {
            addCriterion("supplier_spu_en_name <>", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameGreaterThan(String value) {
            addCriterion("supplier_spu_en_name >", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_spu_en_name >=", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameLessThan(String value) {
            addCriterion("supplier_spu_en_name <", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameLessThanOrEqualTo(String value) {
            addCriterion("supplier_spu_en_name <=", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameLike(String value) {
            addCriterion("supplier_spu_en_name like", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameNotLike(String value) {
            addCriterion("supplier_spu_en_name not like", value, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameIn(List<String> values) {
            addCriterion("supplier_spu_en_name in", values, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameNotIn(List<String> values) {
            addCriterion("supplier_spu_en_name not in", values, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameBetween(String value1, String value2) {
            addCriterion("supplier_spu_en_name between", value1, value2, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnNameNotBetween(String value1, String value2) {
            addCriterion("supplier_spu_en_name not between", value1, value2, "supplierSpuEnName");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleIsNull() {
            addCriterion("supplier_spu_en_subtitle is null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleIsNotNull() {
            addCriterion("supplier_spu_en_subtitle is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleEqualTo(String value) {
            addCriterion("supplier_spu_en_subtitle =", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleNotEqualTo(String value) {
            addCriterion("supplier_spu_en_subtitle <>", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleGreaterThan(String value) {
            addCriterion("supplier_spu_en_subtitle >", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_spu_en_subtitle >=", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleLessThan(String value) {
            addCriterion("supplier_spu_en_subtitle <", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleLessThanOrEqualTo(String value) {
            addCriterion("supplier_spu_en_subtitle <=", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleLike(String value) {
            addCriterion("supplier_spu_en_subtitle like", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleNotLike(String value) {
            addCriterion("supplier_spu_en_subtitle not like", value, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleIn(List<String> values) {
            addCriterion("supplier_spu_en_subtitle in", values, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleNotIn(List<String> values) {
            addCriterion("supplier_spu_en_subtitle not in", values, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleBetween(String value1, String value2) {
            addCriterion("supplier_spu_en_subtitle between", value1, value2, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andSupplierSpuEnSubtitleNotBetween(String value1, String value2) {
            addCriterion("supplier_spu_en_subtitle not between", value1, value2, "supplierSpuEnSubtitle");
            return (Criteria) this;
        }

        public Criteria andExpiredDayIsNull() {
            addCriterion("expired_day is null");
            return (Criteria) this;
        }

        public Criteria andExpiredDayIsNotNull() {
            addCriterion("expired_day is not null");
            return (Criteria) this;
        }

        public Criteria andExpiredDayEqualTo(Integer value) {
            addCriterion("expired_day =", value, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayNotEqualTo(Integer value) {
            addCriterion("expired_day <>", value, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayGreaterThan(Integer value) {
            addCriterion("expired_day >", value, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayGreaterThanOrEqualTo(Integer value) {
            addCriterion("expired_day >=", value, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayLessThan(Integer value) {
            addCriterion("expired_day <", value, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayLessThanOrEqualTo(Integer value) {
            addCriterion("expired_day <=", value, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayIn(List<Integer> values) {
            addCriterion("expired_day in", values, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayNotIn(List<Integer> values) {
            addCriterion("expired_day not in", values, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayBetween(Integer value1, Integer value2) {
            addCriterion("expired_day between", value1, value2, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andExpiredDayNotBetween(Integer value1, Integer value2) {
            addCriterion("expired_day not between", value1, value2, "expiredDay");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementIsNull() {
            addCriterion("is_expire_date_management is null");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementIsNotNull() {
            addCriterion("is_expire_date_management is not null");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementEqualTo(Boolean value) {
            addCriterion("is_expire_date_management =", value, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementNotEqualTo(Boolean value) {
            addCriterion("is_expire_date_management <>", value, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementGreaterThan(Boolean value) {
            addCriterion("is_expire_date_management >", value, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_expire_date_management >=", value, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementLessThan(Boolean value) {
            addCriterion("is_expire_date_management <", value, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementLessThanOrEqualTo(Boolean value) {
            addCriterion("is_expire_date_management <=", value, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementIn(List<Boolean> values) {
            addCriterion("is_expire_date_management in", values, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementNotIn(List<Boolean> values) {
            addCriterion("is_expire_date_management not in", values, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementBetween(Boolean value1, Boolean value2) {
            addCriterion("is_expire_date_management between", value1, value2, "isExpireDateManagement");
            return (Criteria) this;
        }

        public Criteria andIsExpireDateManagementNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_expire_date_management not between", value1, value2, "isExpireDateManagement");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}